USE [Construarte]
GO

/****** Object: Table [dbo].[Tarefa] Script Date: 31/08/2013 14:25:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Tarefa] (
    [TarefaId]        INT            IDENTITY (1, 1) NOT NULL,
    [DescTarefa]      NVARCHAR (100) NULL,
    [DtInicialTarefa] DATE           NOT NULL,
    [DtFinalTarefa]   DATE           NOT NULL,
    [EtapaId]         INT            NULL, 
    CONSTRAINT [FK_Tarefa_Etapa] FOREIGN KEY ([EtapaId]) REFERENCES [Etapa]([EtapaId]), 
    CONSTRAINT [PK_Tarefa] PRIMARY KEY ([TarefaId])
);

